package com.matt.repository.base;
import com.matt.domain.nursery.NurseryScheduleCheck;
import com.matt.domain.nursery.NurseryScheduleRecord;
import com.matt.foundation.query.NurseryScheduleCheckQuery;
import com.matt.foundation.vo.nursery.NurseryScheduleCheckVo;
import com.matt.foundation.vo.nursery.NurseryScheduleRecordVo;

import java.math.BigInteger;
import java.util.Date;
import java.util.List;

/**
 * *******************************
 * Created by lch.
 * form com.matt
 * on 2018/12/05
 * *******************************
 */
public interface NurseryScheduleCheckNativeRepository {

     List<NurseryScheduleCheckVo> list(NurseryScheduleCheckQuery query);

    Long count(NurseryScheduleCheckQuery query);

    NurseryScheduleCheck findByClassesIdCourseDate(String classesId, String courseDate);

    List<NurseryScheduleRecordVo> findByClassesIdAndDate(String classesId, Date beginDate, Date endDate);

    List<Object[]> getAreaIdAndClassesName(String checkId);

    List<BigInteger> getBeginInfo(String classesId, Date beginDate, Date endDate);

    List<BigInteger> getEndInfo(String classesId, Date beginDate, Date endDate);

    List<BigInteger> getNurseryInfo(String classesId, Date beginDate, Date endDate);
}
